Maintaining Budgets for a Specific Account

In MGL, there are two different ways of entering budget information against accounts. This section tells you how to enter budget information manually – that is, you call up each account and then apply budget details directly to the account. The second way is using a budget matrix.

Reference For information on maintaining budgets using a budget matrix, refer to "File - Budget".

You can have four separate budgets (each for 24 months) for each account. The budgets are called Budget 1, Budget 2, Budget 3 and Budget 4. When running financial reports, e.g. the Profit & Loss Report, Micronet prompts you to choose a budget option for that report.

Usually a business decides on its budget for the coming financial year during May/June. The initial budget is set in Budget 1. However, conditions may change and a revised budget can be set – Budget 2, Budget 3, up to Budget 4.

Various recipients of the Profit & Loss Report can have their departmental Income and Expense Report compared against either the Initial Budget, the Revised Budget, or an Adjusted Forecast.

To enter budgets 1-4 for an individual account:

1. Open the Account File Update screen - Sub Account tab and choose to add, insert or edit a sub-account.

Refer to "File - GL Accounts - Sub Account".

Micronet displays the Edit Sub Account screen.

2. Select the Starting Period for the budget.

The period you select must be at the start of a financial year.

3. Select EDIT | BUDGETS and the number of the budget you want to add or change (1, 2, 3, or 4).

Micronet displays the Edit Sub Account Budget Set screen for the budget you selected.

4. Use one of the following methods of entering budget data:

• Enter the budget amount for each month in dollars as required.

Warning Always enter credit balances (income amounts) as negative amounts in the budget set.

• Select EDIT | YEARLY BUDGET – enter a total annual budget amount in dollars and select Accept. Micronet spreads the amount evenly over the 12 months.

Yearly Budget

• Select EDIT | MARKUP METHOD – enter an initial amount to which a markup percentage will be applied each month, then select Accept. Micronet applies the markup percentage to the figure you enter as the first month’s budget, and compounds by that percentage for each following month. The markup percentage is as set in the Budget Matrix field on the Account File Update screen - GL Account tab.

Starting Amount

• Select EDIT | CURRENT BALANCE METHOD – Micronet divides the YTD balance in the GL account by the number of months with transactions to calculate a standard monthly budget amount in dollars. If a Budget Matrix is set on the Account File Update screen - GL Account tab, these amounts will be marked up by the appropriate markup percentage.

5. When you have finished entering budgets for each month on the Edit Sub Account Budget Set screen, select the Accept button.

Micronet redisplays the Edit Sub Account screen so you can add another budget for the GL account if required.

6. When you have finished adding budgets on the Edit Sub Account screen, select the Cancel button.

Micronet redisplays the Account File Update screen – Sub Account tab showing all the sub-accounts for this GL account.

7. Select FILE | SAVE.